Use BD_SYS_ATENCIONES
Go
Create Procedure dbo.GRMaeRequerimiento_Listar
As
Begin

   Select 
      a.iNumReq,
      a.iCodUsuReg,      
      a.dtFecReq,
      a.vHorReq,
      a.iCodEstReq,
      IsNUll(a.vObsReq,'') as vObsReq,
      a.bAprobado,
      a.iCodUsuApro,
      a.dtFecApro,
      a.iCodUsuAte,
      a.dtFecAte,
      IsNull(a.vObsAte,'') as vObsAte,
      a.iCodUsuA,
      a.vNomTer,
      a.dtFecAct
   From GRMaeRequerimiento a(Nolock)   
   Order By dtFecReq desc
   
End